package com.zdkj.subway.check.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zdkj.subway.check.entity.SwPmDeviceOperationCode;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 *  设备表
 */
@Mapper
public interface SwPmDeviceOperationCodeMapper extends BaseMapper<SwPmDeviceOperationCode> {

    //获取设备操作号
    List<SwPmDeviceOperationCode> getSwPmDeviceOperationCodeList(SwPmDeviceOperationCode swPmDeviceOperationCode);

    @Select("select * from sw_pm_device_operation_code where id=#{id} ")
    SwPmDeviceOperationCode getSwPmDeviceOperationCodeById(Integer id);

    @Select("select * from sw_pm_device_operation_code where line_code=#{lineCode} and station_code=#{stationCode}")
    SwPmDeviceOperationCode getSwPmDeviceOperationCodeByLineOrStation(String lineCode,String stationCode);
}

